<?php session_start();$_SESSION['task_id']=1; ?>
<!DOCTYPE html>
<html >
    <head>
    <title>Export XML</title>
    </head>
    <body text="#70B8FF"></body>
        <form action="ExportTraitement.php" method="post">
        <?php 
                $con= mysql_connect("localhost","root","");
                if(!$con){
                    die('Connection Error!:' . mysql_error());
                }
                mysql_select_db ("usabilityevaluation",$con);
                echo "<table>
                        <tr><td>Experiment</td>
                        <td><select name='Experiment'><option></option>";  
                $result = mysql_query("SELECT * FROM experimentation") ;
                while($row = mysql_fetch_array($result)){
                    echo "<option value='$row[Title]'>".$row['Title']." </option>";
                }
                echo "</select></td></tr>";
                
                echo "<tr><td>Participant</td>
                        <td><select name='Participant'><option></option>";  
                $result = mysql_query("SELECT * FROM participant") ;
                while($rowP = mysql_fetch_array($result)){
                    echo "<option value='$rowP[id_participant]'>".$rowP['LastName']." </option>";
                }
                echo "</select></td></tr>";
                mysql_close($con);
            ?>   
            <tr><td></td><td align="right"><input type="submit" value="Export XML"/></td></tr></table>
        </form>
    </body>
</html>